package com.yida.gwj.oracle.basic.domain;

import com.mybatisflex.annotation.Column;
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.KeyType;
import com.mybatisflex.annotation.Table;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/***
 * @title eda
 * @description <TODO description class purpose>
 * @author eda
 * @version 1.0.0
 * @create 2021/9/28 11:57
 **/
@Data
@Table(value = "JCSJ.ZRZ")
public class Zrz {

    /**
     * 自然幢标识码
     */
    @Id(keyType = KeyType.Auto)
    @Column(value = "ZRZBSM")
    private Long ZRZBSM;

    /**
     * 建设用地规划许可证号
     */
    @Column(value = "QBH")
    private String QBH;

    /**
     * 门牌号
     */
    @Column(value = "MPH")
    private String MPH;

    /**
     * 自然幢号
     */
    @Column(value = "ZRZH")
    private String ZRZH;

    /**
     * 建筑物名称
     */
    @Column(value = "JZWMC")
    private String JZWMC;

    /**
     * 房屋结构
     */
    @Column(value = "FWJG")
    private String FWJG;

    /**
     * 竣工日期
     */
    @Column(value = "JGRQ")
    private Date JGRQ;

    /**
     * 建筑高度
     */
    @Column(value = "JZWGD")
    private Integer JZWGD;

    /**
     * 占地面积
     */
    @Column(value = "ZZDMJ")
    private BigDecimal ZZDMJ;

    /**
     * 幢用地面积
     */
    @Column(value = "ZYDMJ")
    private BigDecimal ZYDMJ;

    /**
     * 期房建筑面积
     */
    @Column(value = "QFJZMJ")
    private BigDecimal QFJZMJ;

    /**
     * 实测建筑面积
     */
    @Column(value = "SCJZMJ")
    private BigDecimal SCJZMJ;

    /**
     * 建筑物基本用途
     */
    @Column(value = "JZWJBYT")
    private String JZWJBYT;

    /**
     * 地下层数
     */
    @Column(value = "DSCS")
    private Integer DSCS;

    /**
     * 地上层数
     */
    @Column(value = "DXCS")
    private Integer DXCS;

    /**
     * 地下深度
     */
    @Column(value = "DXSD")
    private Integer DXSD;

    /**
     * X坐标
     */
    @Column(value = "XZB")
    private BigDecimal XZB;

    /**
     * Y坐标
     */
    @Column(value = "YZB")
    private BigDecimal YZB;

    /**
     * 备注
     */
    @Column(value = "REMARK")
    private String REMARK;

    /**
     * 项目标识码
     */
    @Column(value = "XMBSM")
    private Integer XMBSM;

    /**
     * 开发企业标识码
     */
    @Column(value = "KFQYBSM")
    private Integer KFQYBSM;

    /**
     * 项目编号
     */
    @Column(value = "XMBH")
    private Integer XMBH;

    /**
     * 公司编号
     */
    @Column(value = "GSBH")
    private Integer GSBH;

    /**
     * 土地编号
     */
    @Column(value = "TDBH")
    private Integer TDBH;

    /**
     * 项目名称
     */
    @Column(value = "XMMC")
    private String XMMC;

    /**
     * 预售证号
     */
    @Column(value = "YSZH")
    private String YSZH;

    /**
     * 总层数
     */
    @Column(value = "ZCS")
    private String ZCS;

    /**
     * 总套数
     */
    @Column(value = "ZTS")
    private String ZTS;

    /**
     * 开工日期
     */
    @Column(value = "KGRQ")
    private Date KGRQ;

    /**
     * 工程规划许可证号
     */
    @Column(value = "GHXKZ")
    private String GHXKZ;

    /**
     * 施工许可证号
     */
    @Column(value = "SGXKZ")
    private String SGXKZ;

    /**
     * 是否公示
     */
    @Column(value = "SFGS")
    private Integer SFGS;

    /**
     * 是否交易
     */
    @Column(value = "SFJY")
    private Integer SFJY;

    /**
     * 简称年代
     */
    @Column(value = "JCND")
    private Integer JCND;

    /**
     * 区县
     */
    @Column(value = "QX")
    private String QX;

    /**
     * 街道
     */
    @Column(value = "JD")
    private String JD;

    /**
     * 登记日期
     */
    @Column(value = "DJRQ")
    private Date DJRQ;

    @Column(value = "BUILDID")
    private Integer BUILDID;

    @Column(value = "DIRECT_MODIFY")
    private Integer DIRECT_MODIFY;

    @Column(value = "TO_DEL")
    private Integer TO_DEL;

    /**
     * 资源创建案例编号
     */
    @Column(value = "CREATEDOCID")
    private String CREATEDOCID;

    /**
     * 资源创建案例编号
     */
    @Column(value = "PQ")
    private String PQ;

    /**
     * 备用字段1
     */
    @Column(value = "BYO1")
    private String BYO1;

    /**
     * 备用字段2
     */
    @Column(value = "BYO2")
    private String BYO2;

    /**
     * 备用字段3
     */
    @Column(value = "BYO3")
    private Integer BYO3;

    /**
     * 备用字段4
     */
    @Column(value = "BYO4")
    private Integer BYO4;

    /**
     * 是否有效
     */
    @Column(value = "SFYX")
    private Integer SFYX;

    @Column(value = "SYN_FLAG")
    private Integer SYN_FLAG;

    @Column(value = "SYN_TIMESTAMP")
    private Date SYN_TIMESTAMP;

    @Column(value = "SYN_SEQNUM")
    private Integer SYN_SEQNUM;

    @Column(ignore = true)
    private Long totalOwner;

    @Column(ignore = true)
    private Long residence;
}
